package com.cmnit.analysis.dao

import com.cmnit.analysis.common.{TDao, TSql}
import org.apache.log4j.Logger
import org.apache.spark.sql.DataFrame

class GbTollPointDicDao extends TSql with TDao {
  private val logger: Logger = Logger.getLogger(this.getClass)

  /**
   * 加工结果数据
   */
  def GbTollPointDicData(): DataFrame = {
    sparkSQL(
      "SELECT " +
        "ID, " +
        "NAME, " +
        "TYPE, " +
        "TOLLINTERVALS, " +
        "LAT, " +
        "LNG, " +
        "PILENUMBER, " +
        "STATUS,    " +
        "STARTTIME, " +
        "ENDTIME, " +
        "ETCGANTRYHEX, " +
        "RSUMANUID, " +
        "RSUMODEL, " +
        "RSUID, " +
        "VPLRUID, " +
        "VPLRMODEL, " +
        "VPLRID, " +
        "HDVUID, " +
        "HDVMODEL, " +
        "HDVID, " +
        "OPERATION, " +
        "RECORDGENTIME, " +
        "RESPONSECODE, " +
        "RESPONSEINFO, " +
        "RECEIVETIME, " +
        "PROTIME, " +
        "BATCHFILENAME, " +
        "BOUNDARYTYPE, " +
        "CONTROLLERUID, " +
        "CONTROLLERMODEL, " +
        "CONTROLLERID, " +
        "CONTROLLERSYSVER, " +
        "SERVERUID, " +
        "SERVERMODEL, " +
        "SERVERID, " +
        "SERVERSYSVER, " +
        "SERVERDBVER, " +
        "VEHDETECTORUID, " +
        "VEHDETECTORMODEL, " +
        "VEHDETECTORID, " +
        "WEATHERDETECTORUID, " +
        "WEATHERDETECTORMODEL, " +
        "WEATHERDETECTORID, " +
        "CLASSDETECTORUID, " +
        "CLASSDETECTORMODEL, " +
        "CLASSDETECTORID, " +
        "LOADDETECTIONUID, " +
        "LOADDETECTIONMODEL, " +
        "LOADDETECTIONID, " +
        "TEMPCONTROLLERUID, " +
        "TEMPCONTROLLERMODEL, " +
        "TEMPCONTROLLERID, " +
        "POWERCONTROLLERUID, " +
        "POWERCONTROLLERID, " +
        "POWERCONTROLLERMODEL, " +
        "SAFEEQUIPUID, " +
        "SAFEEQUIPMODEL, " +
        "SAFEEQUIPID, " +
        "LINETYPE, " +
        "OPERATORS, " +
        "DATAMERGEPOINT, " +
        "IMEI, " +
        "IP, " +
        "SNMPVERSION, " +
        "SNMPPORT, " +
        "COMMUNITY, " +
        "SECURITYNAME, " +
        "SECURITYLEVEL, " +
        "AUTHENTICATION, " +
        "AUTHKEY, " +
        "ENCRYPTION, " +
        "SECRETKEY, " +
        "USESTATUS, " +
        "GANTARYTYPE, " +
        "LANECOUNT, " +
        "AGENCYGANTRYIDS, " +
        "REETCGANTRYHEX, " +
        "GANTRYSIGN " +
        "FROM " +
        "DIM.DIM_TBL_GbTollPointDic ")
  }
}
